EMT Practice Test

1. Question Content...

---

Question1: A consultant needs to send an email to subscribers who have made a purchase. The data used for the send exists on two data extensions--Subscribers and OrderTable, and the customer would like to include key information from both tables, such as:
* CustomerlD
* FirstName
* EmailAddress
* OrderlD
* OrderDate
* ShippedDate
Which SQL statement should the consultant use?

Question2: A publishing company has presented the following:
* A need to send renewal reminders to customers whose subscriptions expire in 15 days and 7 days.
* A campaign needs to be created and managed by a general marketing user who will not have administrative rights and who is not technical.
* The customer's expiration date is included in the data file.
What component should the customer's solution include?
Choose 3 answers

Question3: How do you use data designer to link the web analytics data to your subscriber data?

Question4: Northern Trail Outfitters wants to target all customers who have registered to receive Push Notifications. Their app uses the Mobile Push SDK.
In which two ways should this segment be created?

Question5: Northern Trail Outfitters wants to know the number of Contacts in their account. This information needs to be emailed to their Chief Marketing Officer on a weekly basis.
What could be configured to meet this request?

Question6: A Marketing Cloud user needs the email addresses of everyone who unsubscribed from a particular email send. This user does NOT know SQL and does NOT have access to the Enhanced FTP account.
What functionality should be used to retrieve the necessary data?

Question7: Northern Trail Outfitters noticed that clicks are NOT showing up on Contact records in Salesforce.
Which two reasons could be the cause?
Choose 2 answers

Question8: A customer wants to automate the process of sending a series of welcome emails based on the Subscriber's dat a. Emails should be sent weekly for up to five weeks. If a subscriber makes a purchase, they should stop receiving welcome emails. A Boolean flag should be set in the data extension if the subscriber makes it through the welcome series.
Which steps should be used to accomplish this in Journey Builder?

Question9: Northern Trail Outfitters wants to import new contacts gathered from an external web form. The entries are being collected at high frequency, potentially thousands per minutes. The data does not need to be immediately ingested into Marketing Cloud as it is used in a daily scheduled automation.
What Should be recommended?

Question10: A financial services customer wants to send email to customers who log in for the first on a new IP. This message should be deployed as fast as possible due to its sensitive content. The message contain information related to the login IP.
What should a consultant recommend to deploy the email?

Question11: An entertainment company is hosting events across the country in different venues. They want to use Contact Builder to feed Journey Builder. Contacts who enter a journey will go through a decision split based on the type of event. The journey will send a series of emails and one of them will contain the venue details dynamically populated with AMPscript.
The company collects the following information:
*Customer data (email address, first name, last name....)
*Event registration (email address, event ID, event name, event type, venue ID....)
*Venue details (venue ID, venue name, venue address....)
*Payment details (email address, event ID, total paid....)
The company does NOT want to link everything in Contact Builder. Which two data extensions should be incorporated inside Contact Builder? Choose 2 answers

Question12: Which three statements are correct regarding the automation tools in Marketing Cloud?
Choose 3 answers

Question13: Northern Trail Outfitters (NTO) wants to use Marketing Cloud to solicit customer service feedback. If a customer indicates they are unhappy with the service they have received, NTO wants a new case to be created in Service Cloud. NTO is unsure of what is possible within Marketing Cloud but would like to use as much native functionality as possible.
What approach would a consultant recommend?

Question14: What are the similarities between Automation Studio and Journey Builder?

Question15: Northern Trail Outfitters (NTO) wants to implement a drip campaign to its highest-value outdoor sports customers. NTO is including a deep product discount and wants to limit the audience to not only its best customers, but also those customers most likely to respond.
Which three criteria should they use to create an audience for this campaign? Choose 3 answers

Question16: A retail customer expanded their portfolio to include additional product lines in addition to their already popular offerings. They want to give subscribers the ability to unsubscribe via email from the specific subsections while still remaining on the main commercial communications audience. This option will be included in the footer attached to the unsubscribe URL and as an option on their subscription center.
Which model would meet the requirements?

Question17: Northern Trail Outfitters is expanding globally into 16 new countries and wants to start localizing their email content to speak to subscribers in their own language. They want to do this as efficiently as possible and are anticipating growth into other locales in the near future.
Which two options could be recommended? (Choose 2 answers)

Question18: Northern Trail Outfitters (NTO) wants to use Case data from Service Cloud as part of their current email messaging campaign. They want to import cases that indicate the customer wants someone to contact them after the case is closed. NTO tracks cases with a checkbox field called "Contact Me".

Question19: A customer needs to compare the engagement across three creative versions, and then send a follow-up email for those contacts who did not engage with any of the test versions.
Which sequence of activities would best accomplish this?

Question20: Northern Trail Outfitters has been using Marketing Cloud for one of their brands for the last year and wants to migrate another brand to their portfolio. The two brands have contrasting target groups and identities so they need the emails and landing pages to have different styles that refrain from mentioning the other brand in any way.
What should be recommended?

Question21: Northern Trail Outfitters received an email about reaching API limits within Salesforce and they think this is caused by the integrated Marketing Cloud account.
Which two types of API calls are counted against the rolling 24-hour limit?

Question22: A small restaurant franchise wants to implement Marketing Cloud to support their franchise owners. The owners of franchised stores add a customized local message to the marketing campaign.
What hierarchy should be recommended?

Question23: A mobile contact is not receiving SMS messages sent via MobileConnect.
In which two ways could a consultant troubleshoot this issue? (Choose 2 answers)

Question24: A company collects subscriptions on its website. It does the following:
* Compiles that subscription list in a database in the website Content Management System (CMS).
* Posts this encrypted list to Marketing Cloud nightly at 11 p.m.
* Uses Marketing Cloud as the database of record.
* Sends up to five emails a week based on subscriber engagement with prior sends.
Which automation sequence (excluding waits) should cover these requirements?

Question25: A customer needs to import data from an SFTP site. The customer wants to:
* Segment the contents of the file and then send emails.
* Transfer the file to the SFTP site at various times daily.
* Send to data extensions.
Which workflow should meet these requirements?

Question26: A customer is creating a re-engagement campaign. The Campaign only targets subscribers who have had emails fail at send time due to held status within the last 60days. The goal is to send an SMS to the subscribers asking them if they want to update their email address.
What should a consultant recommend to meet the criteria?

Question27: Northern Trail Outfitters wants a simple segmentation strategy for identifying subscribers for their emails.
What solution should they use?

Question28: An existing triggered send needs to be updated with new content
Select the correct sequence

Question29: A customer wants to configure appointment reminders for patients in their clinic. The reminder should be sent day before the appointment date at 10 a.m and the appointment record should be updated in the patient was sent a reminder email.
What solution could be recommended?

Question30: A customer frequently holds seminars and other events to interface with their customers. They plan to do the following:
*Use SmartCapture forms to write data into event registration data extensions.
*Cross-reference the records in each registration data extension with corresponding invitation email sends.
*Send a follow-up email to customers who click on the registration link in the invitation email, but do not complete registration.
Which skill is needed to build an efficient solution?

Question31: What are two ways Contact builder can alter the data in Data Extensions

Question32: An online retailer would like to utilize Journey Builder interactions for sending post-purchase communications to their customers.
What Contact Entry mode best fits this scenario?

Question33: A customer has several values that need to be used in the body of an email send.
* The data would be stored in a reference data extension, related on SubscriberKey
* There may be one or more records for each subscriber
* The audience is generally over 1 million subscribers
* The content is time sensitive and should be sent as quickly as possible
* The customer is not using "Catch and release" sending
* The reference data extension contains 25 columns
What method should be used

Question34: A customer wants to display a subscriber's first name and the date of send in its monthly newsletter, subscriber first name data is stored in data extension that won't be used in the send definition.
Which option should be in this scenario?

Question35: A real estate agency wants to send out a biweekly newsletter with the list of properties for all new contacts added to a newsletter campaign in their Salesforce CRM. The journey consists of an initial message with property listings and a follow up to those who have engaged with the content.
The rules around which properties are matched to the contact depend on agent assigned as a contact owner, other agents who might have interacted with the contact, and contact's property interest. The data model has a relationship between contact > person account > real estate agent > property objects and all of those are available in CRM as well as synchronized to Marketing Cloud.
What solution should be recommended for execution efficiency?

Question36: To fuel their expansion, Northern Trail Outfitters (NTO) recently acquired Eagle Outfitters (EO). There is currently a 30 percent overlap between the guests of each brand and they will be pursuing cross-marketing opportunities. It was recommended that their Marketing Cloud account now include a separate business unit for EO and the company secure a new sender authentication package for EO using the private domain e-EO.com.
Select the statement that correctly describes the implication of this recommendation.
Choose 2 answers

Question37: How are Publication Lists used?

Question38: A customer needs to import data from an SFTP site. The customer wants to:
* Segment the contents of the file and then send emails.
* Transfer the file to the SFTP site at various times daily.
* Send to data extensions.
What sequence of automation activities should meet these requirements?

Question39: Northern Trail Outfitters (NTO) is launching a new subsidiary brand, Cloud Kicks, within the next six months. Cloud Kicks anticipates sending approximately 50,000 emails per month from a child business unit. NTO will execute a large campaign announcing and associating itself with Cloud Kicks as part of the brand kickoff and is comfortable sharing digital properties with them. Cloud Kicks wants to utilize a custom sending domain, but deliverability is a primary concern.
What approach should be recommended?

Question40: Northern Trail Outfitters (NTO) is migrating from a series of local legacy email automation tools to a single global Marketing Cloud instance to leverage its multi-channels abilities as well as native Salesforce Connector to their global Sales Cloud instance.
Which three factors Should be considered before finalizing the number of business unit they need to purchase? (Choose 3 answers)

Question41: Northern Trail Outfitters wants to have a periodic, dynamic newsletter send to a set data extension, but the data in this data extension will be regularly updated and the subscribers inside could be removed/added multiple times.
What option should speed up the delivery while meeting these criteria?

Question42: A customer notices their open and click rates are very low.
Which two aspects of list hygiene should be recommended to improve engagement rates? (Choose 2 answers)

Question43: A customer wants to set up a real-time, API-driven way to be alerted when transactional messages fail to send out of Marketing Cloud. They are currently in the process of hiring a full-time developer but want an implementation in place for the developer to maintain.
What should the customer have in place to ensure this solution can be implemented?

Question44: A customer wants to automate the send of a monthly promotional email. The customer will upload an audience file to their account's Enhanced SFTP on a monthly basis on the 15th day of each month, expecting the email to be deployed upon completion of the import activity. However, if the 15th of the month falls on a Saturday or Sunday, the customer will provide the file on the Friday prior to the 15th and expect the promotional email to be sent on that Friday.
Which method should be used to automate their monthly promotional email?

Question45: Northern Trail Outfitters (NTO) is launching a new campaign, driving it to redesign its data structure. NTO needs to change the cardinality between two data extensions inside Contact Builder.
What are two consequences of this change? Choose 2 answers

Question46: A customer wants to link web analytics data to subscriber data.
How should this be set up in Data Designer?

Question47: For security reasons, Northern Trail Outfitters indicates they cannot store PII directly within their Marketing Cloud account. They are considering implementing Tokenized Sending to pull PII from their data warehouse at send time. They indicate they send several large, time-sensitive emails per year.
Which two considerations should be made about Tokenized Sending? (Choose 2 answers)

Question48: A customer has several values that need to be used in the body of an email send:
* The data would be stored in a reference data extension, related on SubscriberKey.
* There may be one or more records for each subscriber.
* The audience is generally over 1 million subscribers.
* The content is time sensitive and should be sent as quickly as possible.
* The customer is not using "catch and release" sending.
* The reference data extension contains 25 columns.
Which method should be used?

Question49: Northern Trail Outfitters (NTO) has decided to use Journey builder to launch event-driven lifecycle marketing programs. This includes personalized interactions with customers with the goal of increasing purchase frequency.
What two pieces of information would help NTO achieve this objective?
Choose 2 answers:

Question50: Northern Trail Outfitters wants to integrate Marketing Cloud with its existing point-of-sale system in order in email purchase receipt to its customers. The point-of-sale data will need to be transformed to be received by the Marketing Cloud triggered send API.
What extension product should be used to accomplish this integration?

Question51: A consultant configured a triggered send definition in Sales Cloud for a customer using Marketing Cloud Connect, The trigger is on a Custom Object called 'Shipments' and is enabled for Triggered Sends in Setup.
Which two configuration requirements should be considered when troubleshooting? (Choose 2 answers)

Question52: The Northern Trail Outfitters' (NTO) marketing team is launching a new email campaign. NTO's Email Specialist wants to perform quality assurance checks on the email prior to send using the Send Preview functionality.
Which three items does Preview and Test check for in an email message? Choose 3 answers

Question53: Northern Trail Outfitters is using Journey Builder to send emails to loyalty members based on recent activity. They anticipate that approximately half of their contacts will meet the entry criteria for their journey.
How should they configure their entry source?

Question54: Northern Trail Outfitters assigns a 15-digit integer as their Order ID which will be used as the primary key of a data extension. The import file contains leading zeros, but they will NOT be included in the final values.
Which data type should they use for the Order ID field?

Question55: The customer has the following requirements for storing engagement data in their data warehouse:
* All email open and click activity must be pulled daily from MC
* Output files must meet the specific requirements for the data warehouse
* All the activity must be provided via FTP in one file.
Which automation workflow meets the customer requirements?

Question56: North Trail Outfitters (NTO) wants to automate the sending of shipping notices and a customer survey.
*Shipping notices will be sent once a day.
*The shipping file will be placed on the FTP sometime after 4:00 p.m.
*The shipping data will be stored in the shipping Notice data extension.
*A field in the data extension will contain the shipping data.
*The survey needs to be sent at 9:00 a.m., exactly 10 days after the customers order ships.
Which workflow would most effectively enable NTO to do this?
A)

B)

C)

D)

Question57: Northern Trail Outfitters (NTO):
* Employs Email Specialists responsible for creating content, testing, sending emails, defining the activities for Automation Studio, and creating automations.
* Prefers not to use custom roles unless it is absolutely necessary.
* Email Specialist resides in multiple business units.
Using best practices, how should a consultant create and assign roles for NTO?

Question58: A customer wants to create a journey with the goal of making users activate their accounts within 72 h of registration. New account registrations are stored in a data extension via an API call with a Boolean field indicating whether the subscriber has activated their account. The journey should send activation reminder emails 24 and 48 h after creating an account. The user exits the journey if they activate their account.
Which activities should be included in the customer's journey?

Question59: When more than one subscriber email address field is created within Contact Builder, what action tells the platform which email address to prioritize in the Email application?

Question60: Northern Trail Outfitters (NTO) wants to implement an abandon cart journey. The data for the journey exists in three separate data extensions (DE).
* The first DE is populated by web analytics data, and does not contain a Subscriber Key or Email Address value.
* A Customer Reference DE is updated daily and holds subscriber information.
* The third DE is populated by a file sent to the SFTP after five days If the customer has not purchased the abandoned items.
* The third DE will be used in the journey for a decision split, and it does not contain a Subscriber Key or Email Address.
* If the web analytics file is empty, NTO does not want the automation to finish running.
Which order of activities should be used to fulfill this requirement?

Question61: A university plans to use Journey Builder to improve their 1:1 marketing to potential students, current students, and alumni. The university currently has student data in Sales Cloud. Other data, such as course catalog, student demographics, and alumni information, is stored in external systems.
Which two actions should be consultant recommend? Choose 2 answers

Question62: Northern Trail Outfitters is sending email messages using Marketing Cloud Connect through the Sales Cloud user interface. All of their sends initiated from Sales Cloud have a status of failed.
What should the consultant do to diagnose the issue?

Question63: A customer wants to integrate their website with Marketing Cloud so that users can update their marketing communication preferences. The customer has in-house web development resources available and is interested in leveraging tools such as Journey Builder in the future.
What solution should the consultant propose, given the customer's requirements and available resources?

Question64: A subscriber asked to be removed from a customer's email list multiple times by replying directly to the customer's marketing message, but continues to receive emails.
Which steps will solve how replies are managed by the application?
Choose 3 answers

Question65: Northern Trail Outfitters has recently configured MobileConnect and wants to perform single send-outs from within MobileConnect using data extensions that contain automatically refreshed segments.
Which two fields would need to be added to enable these data extensions for sending? (Choose 2 answers)

Question66: ABC Company wants to automate the sending of shipping notices and a customer survey.
* Shipping notices will be sent once a day.
* The shipping file will be placed on the FTP some time after 4:00 p.m.
* The shipping data will be sorted in the Shipping Notice data extension.
* A field in the data extension will contain the shipping date.
* The survey needs to be sent at 9:00 a.m., exactly 10 days after the customer's order ships.
Which workflow would most effectively enable ABC Company to do this?

Question67: A financial services customer states that families often share email addresses across multiple checking, savings, loan, and credit accounts. The customer needs to allow individual accounts to use the same email address in Marketing Cloud but maintain separate subscriber attributes.
Which component should be discussed with the customer to allow for this use case?

Question68: Northern Trail Outfitters has integrated their Marketing Cloud account with their Salesforce sandbox.
In what order should the steps be performed to refresh the sandbox in their integrated account?

Question69: A marketer wants to capture open-ended feedback from customers via SMS and write it to a data extension.
How could MobileConnect be used to accomplish this?

Question70: Northern Trail Outfitters receives data from their point-of-sale system every night. The file is placed on their Enhanced FTP, but there is not a consistent time or naming convention for the file.
In which two ways should they set up their automation to import the data from the file on a nightly bais? (Choose 2 answers)

Question71: Subscribers are collected on a customer's website whose subscription database of record is Salesforce Marketing Cloud. The customer sends up to 5 emails per week based on subscriber activity.
The list is:
* Compiled in a database in the website Content Management System (CMS).
* Imported into Marketing Cloud nightly at 11 p.m.
What action should be taken if a third party is sending a message for the customer outside of the Marketing Cloud?

Question72: An analytics team wants to get real-time updates on transactional email metrics, specifically Sent and NotSent, to ensure they are fulfilling a legal obligation due to the nature of their messages.
What method should be suggested in this scenario?

Question73: If I want to introduce a new line of footwear. I am excluding anyone who does not have shoe as an attribute listed in their preference center. I plan to send the emails daily. After a short time, I notice many people updating their preferences, and less emails are going out.
What is the issue causing less emails to go out? Select one.

Question74: Northern Trail Outfitters recently purchased Marketing Cloud to start running cross-channel campaigns. They are looking for guidance on which value to use as the subscriber key.
Which two options should the consultant recommend? (Choose 2 answers)

Question75: Northern Trail Outfitters is sending to an audience of over one million subscribers. They will use 10 different personalized fields in the email which reside in multiple data extensions. The goal is a timely email send from start to finish as it contains a limited quantity, first come-first served, special offer.
How should they accomplish this task?

Question76: A retail company does business in both the United States and Canad
a. They have a loyalty program in which a customer can enroll. The company will provide a pre-segmented customer file, per campaign, which has a "Version" data field indicating the type of email the customer is to receive.
Which two questions should be asked to determine a data/segmentation strategy?
Choose 2 answers

Question77: Northern Trail Outfitters (NTO) uses Marketing Cloud to connect with its individual consumers, retailers and wholesale buyers, and its corporate apparel customers. Marketing Cloud is currently configured with data extensions containing Store, Order, Product, and Contact information. NTO is in the process of implementing Data Designer and linking its data extensions.
How should consumers, retailers, and wholesale buyers be defined in Data Designer?

Question78: Which statement is correct regarding tracking aliases? Choose 2 answers

Question79: Northern Trail Outfitters has several business units (BU) and each BU uses specific data extensions, like Product Information.
How Should they configure these data sources?

Question80: What is a capability of the Import within Contact Builder? Choose 2 answers

Question81: Northern Trail Outfitters (NTO) wants to send out a communication to subscribers who have not made a purchase the last six months. Customer are often opted-in to more than one messaging channel. NTO would like to be able to communicate the same message across all channels.
Which flow would meet their needs?

Question82: Northern Trail Outfitters (NTO) plans to use Contact Builder to increase the scope of customer information they can see in an effort to establish more effective 1:1 relationships. NTO has a separate instance of Salesforce Sales Cloud that serves as their current customer master database.
What action should be taken when using Contact Builder? Choose 2 answers

Question83: A customer would like to send a quarterly re-engagement email to subscribers who have not opened in the previous three months. The customer's plans are to:
* Use an existing Paste HTML email for the first send.
* Make only minor changes to the email creative for future sends.
* Use an existing Measure to build the subscriber audience for current and future sends.
* Deploy emails manually for now, but possibly automate in the future.
Which configuration is recommended for the re-engagement email send?